<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( '../global/initialize.php' );

$ruler_expedition_id = formatInput( $_GET[ 'id' ] );
$query = "SELECT ruler_id, rank FROM ruler_expedition WHERE ruler_expedition_id = " . $ruler_expedition_id;
$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
$row = mysql_fetch_array($result, MYSQL_ASSOC);
if( $row[ 'ruler_id' ] == $_SESSION[ 'ruler_id' ] ) {
	$rank = $row[ 'rank' ];
	$query = "DELETE FROM ruler_expedition WHERE ruler_expedition_id = " . $ruler_expedition_id;
	mysql_query( $query ) or die( "Query failed : " . mysql_error() );
	$query = "SELECT rank, ruler_expedition_id FROM ruler_expedition " .
			"WHERE rank > " . $rank . " AND ruler_id = " . $_SESSION[ 'ruler_id' ];
	$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
	$num = mysql_numrows( $result );
    $i = 0;
    while ( $i < $num ) {
 		if( mysql_result( $result, $i, "rank" ) - 1 == 0 ) {
			$query = "UPDATE ruler_expedition SET rank = 0, pending = 1 WHERE ruler_expedition_id = " . mysql_result( $result, $i, "ruler_expedition_id" );
			mysql_query( $query ) or die( "Query failed : " . mysql_error() );
		}
		else {
			$query = "UPDATE ruler_expedition SET rank = " . ( mysql_result( $result, $i, "rank" ) - 1 ) . " WHERE ruler_expedition_id = " . mysql_result( $result, $i, "ruler_expedition_id" );
			mysql_query( $query ) or die( "Query failed : " . mysql_error() );
		}
    	$i ++;	
    }
}
header( "Location: expeditions.php" );
?>